﻿using System;
using System.Collections.Generic;
using System.Text;

namespace Glorysoft.EAP.Core.Entities.DB.Service
{
   public class EAP_PROBERCARDService
    {
        public static List<EAP_PROBERCARD> SelectPROBERCARDByCodeID(string codeID)
        {
            return FreeSqlContext.FreeSqlConnect.Select<EAP_PROBERCARD,EAP_PROBERCARDSTATUS>().LeftJoin((a,b)=>a.CARDID==b.CARDID).Where((a,b) => a.CARDID == codeID && b.STATUS== "In use").ToList();

        }

    }
}
